package com.kingzoon.seckill.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;

public class FmsCapUnfrozenExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Integer offset;

    public FmsCapUnfrozenExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setLimit(Integer limit) {
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return offset;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andExchangeIdIsNull() {
            addCriterion("EXCHANGE_ID is null");
            return (Criteria) this;
        }

        public Criteria andExchangeIdIsNotNull() {
            addCriterion("EXCHANGE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andExchangeIdEqualTo(String value) {
            addCriterion("EXCHANGE_ID =", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdNotEqualTo(String value) {
            addCriterion("EXCHANGE_ID <>", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdGreaterThan(String value) {
            addCriterion("EXCHANGE_ID >", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdGreaterThanOrEqualTo(String value) {
            addCriterion("EXCHANGE_ID >=", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdLessThan(String value) {
            addCriterion("EXCHANGE_ID <", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdLessThanOrEqualTo(String value) {
            addCriterion("EXCHANGE_ID <=", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdLike(String value) {
            addCriterion("EXCHANGE_ID like", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdNotLike(String value) {
            addCriterion("EXCHANGE_ID not like", value, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdIn(List<String> values) {
            addCriterion("EXCHANGE_ID in", values, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdNotIn(List<String> values) {
            addCriterion("EXCHANGE_ID not in", values, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdBetween(String value1, String value2) {
            addCriterion("EXCHANGE_ID between", value1, value2, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andExchangeIdNotBetween(String value1, String value2) {
            addCriterion("EXCHANGE_ID not between", value1, value2, "exchangeId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdIsNull() {
            addCriterion("DISTRIBUTOR_ID is null");
            return (Criteria) this;
        }

        public Criteria andDistributorIdIsNotNull() {
            addCriterion("DISTRIBUTOR_ID is not null");
            return (Criteria) this;
        }

        public Criteria andDistributorIdEqualTo(String value) {
            addCriterion("DISTRIBUTOR_ID =", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdNotEqualTo(String value) {
            addCriterion("DISTRIBUTOR_ID <>", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdGreaterThan(String value) {
            addCriterion("DISTRIBUTOR_ID >", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdGreaterThanOrEqualTo(String value) {
            addCriterion("DISTRIBUTOR_ID >=", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdLessThan(String value) {
            addCriterion("DISTRIBUTOR_ID <", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdLessThanOrEqualTo(String value) {
            addCriterion("DISTRIBUTOR_ID <=", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdLike(String value) {
            addCriterion("DISTRIBUTOR_ID like", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdNotLike(String value) {
            addCriterion("DISTRIBUTOR_ID not like", value, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdIn(List<String> values) {
            addCriterion("DISTRIBUTOR_ID in", values, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdNotIn(List<String> values) {
            addCriterion("DISTRIBUTOR_ID not in", values, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdBetween(String value1, String value2) {
            addCriterion("DISTRIBUTOR_ID between", value1, value2, "distributorId");
            return (Criteria) this;
        }

        public Criteria andDistributorIdNotBetween(String value1, String value2) {
            addCriterion("DISTRIBUTOR_ID not between", value1, value2, "distributorId");
            return (Criteria) this;
        }

        public Criteria andMemberIdIsNull() {
            addCriterion("MEMBER_ID is null");
            return (Criteria) this;
        }

        public Criteria andMemberIdIsNotNull() {
            addCriterion("MEMBER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andMemberIdEqualTo(String value) {
            addCriterion("MEMBER_ID =", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotEqualTo(String value) {
            addCriterion("MEMBER_ID <>", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdGreaterThan(String value) {
            addCriterion("MEMBER_ID >", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdGreaterThanOrEqualTo(String value) {
            addCriterion("MEMBER_ID >=", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLessThan(String value) {
            addCriterion("MEMBER_ID <", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLessThanOrEqualTo(String value) {
            addCriterion("MEMBER_ID <=", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLike(String value) {
            addCriterion("MEMBER_ID like", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotLike(String value) {
            addCriterion("MEMBER_ID not like", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdIn(List<String> values) {
            addCriterion("MEMBER_ID in", values, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotIn(List<String> values) {
            addCriterion("MEMBER_ID not in", values, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdBetween(String value1, String value2) {
            addCriterion("MEMBER_ID between", value1, value2, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotBetween(String value1, String value2) {
            addCriterion("MEMBER_ID not between", value1, value2, "memberId");
            return (Criteria) this;
        }

        public Criteria andUnfronzenSerialnoIsNull() {
            addCriterion("UNFRONZEN_SERIALNO is null");
            return (Criteria) this;
        }

        public Criteria andUnfronzenSerialnoIsNotNull() {
            addCriterion("UNFRONZEN_SERIALNO is not null");
            return (Criteria) this;
        }

        public Criteria andUnfronzenSerialnoEqualTo(String value) {
            addCriterion("UNFRONZEN_SERIALNO =", value, "unfronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andUnfronzenSerialnoNotEqualTo(String value) {
            addCriterion("UNFRONZEN_SERIALNO <>", value, "unfronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andUnfronzenSerialnoGreaterThan(String value) {
            addCriterion("UNFRONZEN_SERIALNO >", value, "unfronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andUnfronzenSerialnoGreaterThanOrEqualTo(String value) {
            addCriterion("UNFRONZEN_SERIALNO >=", value, "unfronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andUnfronzenSerialnoLessThan(String value) {
            addCriterion("UNFRONZEN_SERIALNO <", value, "unfronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andUnfronzenSerialnoLessThanOrEqualTo(String value) {
            addCriterion("UNFRONZEN_SERIALNO <=", value, "unfronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andUnfronzenSerialnoLike(String value) {
            addCriterion("UNFRONZEN_SERIALNO like", value, "unfronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andUnfronzenSerialnoNotLike(String value) {
            addCriterion("UNFRONZEN_SERIALNO not like", value, "unfronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andUnfronzenSerialnoIn(List<String> values) {
            addCriterion("UNFRONZEN_SERIALNO in", values, "unfronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andUnfronzenSerialnoNotIn(List<String> values) {
            addCriterion("UNFRONZEN_SERIALNO not in", values, "unfronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andUnfronzenSerialnoBetween(String value1, String value2) {
            addCriterion("UNFRONZEN_SERIALNO between", value1, value2, "unfronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andUnfronzenSerialnoNotBetween(String value1, String value2) {
            addCriterion("UNFRONZEN_SERIALNO not between", value1, value2, "unfronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andFronzenSerialnoIsNull() {
            addCriterion("FRONZEN_SERIALNO is null");
            return (Criteria) this;
        }

        public Criteria andFronzenSerialnoIsNotNull() {
            addCriterion("FRONZEN_SERIALNO is not null");
            return (Criteria) this;
        }

        public Criteria andFronzenSerialnoEqualTo(String value) {
            addCriterion("FRONZEN_SERIALNO =", value, "fronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andFronzenSerialnoNotEqualTo(String value) {
            addCriterion("FRONZEN_SERIALNO <>", value, "fronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andFronzenSerialnoGreaterThan(String value) {
            addCriterion("FRONZEN_SERIALNO >", value, "fronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andFronzenSerialnoGreaterThanOrEqualTo(String value) {
            addCriterion("FRONZEN_SERIALNO >=", value, "fronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andFronzenSerialnoLessThan(String value) {
            addCriterion("FRONZEN_SERIALNO <", value, "fronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andFronzenSerialnoLessThanOrEqualTo(String value) {
            addCriterion("FRONZEN_SERIALNO <=", value, "fronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andFronzenSerialnoLike(String value) {
            addCriterion("FRONZEN_SERIALNO like", value, "fronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andFronzenSerialnoNotLike(String value) {
            addCriterion("FRONZEN_SERIALNO not like", value, "fronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andFronzenSerialnoIn(List<String> values) {
            addCriterion("FRONZEN_SERIALNO in", values, "fronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andFronzenSerialnoNotIn(List<String> values) {
            addCriterion("FRONZEN_SERIALNO not in", values, "fronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andFronzenSerialnoBetween(String value1, String value2) {
            addCriterion("FRONZEN_SERIALNO between", value1, value2, "fronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andFronzenSerialnoNotBetween(String value1, String value2) {
            addCriterion("FRONZEN_SERIALNO not between", value1, value2, "fronzenSerialno");
            return (Criteria) this;
        }

        public Criteria andConfirmSerialnoIsNull() {
            addCriterion("CONFIRM_SERIALNO is null");
            return (Criteria) this;
        }

        public Criteria andConfirmSerialnoIsNotNull() {
            addCriterion("CONFIRM_SERIALNO is not null");
            return (Criteria) this;
        }

        public Criteria andConfirmSerialnoEqualTo(String value) {
            addCriterion("CONFIRM_SERIALNO =", value, "confirmSerialno");
            return (Criteria) this;
        }

        public Criteria andConfirmSerialnoNotEqualTo(String value) {
            addCriterion("CONFIRM_SERIALNO <>", value, "confirmSerialno");
            return (Criteria) this;
        }

        public Criteria andConfirmSerialnoGreaterThan(String value) {
            addCriterion("CONFIRM_SERIALNO >", value, "confirmSerialno");
            return (Criteria) this;
        }

        public Criteria andConfirmSerialnoGreaterThanOrEqualTo(String value) {
            addCriterion("CONFIRM_SERIALNO >=", value, "confirmSerialno");
            return (Criteria) this;
        }

        public Criteria andConfirmSerialnoLessThan(String value) {
            addCriterion("CONFIRM_SERIALNO <", value, "confirmSerialno");
            return (Criteria) this;
        }

        public Criteria andConfirmSerialnoLessThanOrEqualTo(String value) {
            addCriterion("CONFIRM_SERIALNO <=", value, "confirmSerialno");
            return (Criteria) this;
        }

        public Criteria andConfirmSerialnoLike(String value) {
            addCriterion("CONFIRM_SERIALNO like", value, "confirmSerialno");
            return (Criteria) this;
        }

        public Criteria andConfirmSerialnoNotLike(String value) {
            addCriterion("CONFIRM_SERIALNO not like", value, "confirmSerialno");
            return (Criteria) this;
        }

        public Criteria andConfirmSerialnoIn(List<String> values) {
            addCriterion("CONFIRM_SERIALNO in", values, "confirmSerialno");
            return (Criteria) this;
        }

        public Criteria andConfirmSerialnoNotIn(List<String> values) {
            addCriterion("CONFIRM_SERIALNO not in", values, "confirmSerialno");
            return (Criteria) this;
        }

        public Criteria andConfirmSerialnoBetween(String value1, String value2) {
            addCriterion("CONFIRM_SERIALNO between", value1, value2, "confirmSerialno");
            return (Criteria) this;
        }

        public Criteria andConfirmSerialnoNotBetween(String value1, String value2) {
            addCriterion("CONFIRM_SERIALNO not between", value1, value2, "confirmSerialno");
            return (Criteria) this;
        }

        public Criteria andCapitalAccountIsNull() {
            addCriterion("CAPITAL_ACCOUNT is null");
            return (Criteria) this;
        }

        public Criteria andCapitalAccountIsNotNull() {
            addCriterion("CAPITAL_ACCOUNT is not null");
            return (Criteria) this;
        }

        public Criteria andCapitalAccountEqualTo(String value) {
            addCriterion("CAPITAL_ACCOUNT =", value, "capitalAccount");
            return (Criteria) this;
        }

        public Criteria andCapitalAccountNotEqualTo(String value) {
            addCriterion("CAPITAL_ACCOUNT <>", value, "capitalAccount");
            return (Criteria) this;
        }

        public Criteria andCapitalAccountGreaterThan(String value) {
            addCriterion("CAPITAL_ACCOUNT >", value, "capitalAccount");
            return (Criteria) this;
        }

        public Criteria andCapitalAccountGreaterThanOrEqualTo(String value) {
            addCriterion("CAPITAL_ACCOUNT >=", value, "capitalAccount");
            return (Criteria) this;
        }

        public Criteria andCapitalAccountLessThan(String value) {
            addCriterion("CAPITAL_ACCOUNT <", value, "capitalAccount");
            return (Criteria) this;
        }

        public Criteria andCapitalAccountLessThanOrEqualTo(String value) {
            addCriterion("CAPITAL_ACCOUNT <=", value, "capitalAccount");
            return (Criteria) this;
        }

        public Criteria andCapitalAccountLike(String value) {
            addCriterion("CAPITAL_ACCOUNT like", value, "capitalAccount");
            return (Criteria) this;
        }

        public Criteria andCapitalAccountNotLike(String value) {
            addCriterion("CAPITAL_ACCOUNT not like", value, "capitalAccount");
            return (Criteria) this;
        }

        public Criteria andCapitalAccountIn(List<String> values) {
            addCriterion("CAPITAL_ACCOUNT in", values, "capitalAccount");
            return (Criteria) this;
        }

        public Criteria andCapitalAccountNotIn(List<String> values) {
            addCriterion("CAPITAL_ACCOUNT not in", values, "capitalAccount");
            return (Criteria) this;
        }

        public Criteria andCapitalAccountBetween(String value1, String value2) {
            addCriterion("CAPITAL_ACCOUNT between", value1, value2, "capitalAccount");
            return (Criteria) this;
        }

        public Criteria andCapitalAccountNotBetween(String value1, String value2) {
            addCriterion("CAPITAL_ACCOUNT not between", value1, value2, "capitalAccount");
            return (Criteria) this;
        }

        public Criteria andDesCapitalAccountIsNull() {
            addCriterion("DES_CAPITAL_ACCOUNT is null");
            return (Criteria) this;
        }

        public Criteria andDesCapitalAccountIsNotNull() {
            addCriterion("DES_CAPITAL_ACCOUNT is not null");
            return (Criteria) this;
        }

        public Criteria andDesCapitalAccountEqualTo(String value) {
            addCriterion("DES_CAPITAL_ACCOUNT =", value, "desCapitalAccount");
            return (Criteria) this;
        }

        public Criteria andDesCapitalAccountNotEqualTo(String value) {
            addCriterion("DES_CAPITAL_ACCOUNT <>", value, "desCapitalAccount");
            return (Criteria) this;
        }

        public Criteria andDesCapitalAccountGreaterThan(String value) {
            addCriterion("DES_CAPITAL_ACCOUNT >", value, "desCapitalAccount");
            return (Criteria) this;
        }

        public Criteria andDesCapitalAccountGreaterThanOrEqualTo(String value) {
            addCriterion("DES_CAPITAL_ACCOUNT >=", value, "desCapitalAccount");
            return (Criteria) this;
        }

        public Criteria andDesCapitalAccountLessThan(String value) {
            addCriterion("DES_CAPITAL_ACCOUNT <", value, "desCapitalAccount");
            return (Criteria) this;
        }

        public Criteria andDesCapitalAccountLessThanOrEqualTo(String value) {
            addCriterion("DES_CAPITAL_ACCOUNT <=", value, "desCapitalAccount");
            return (Criteria) this;
        }

        public Criteria andDesCapitalAccountLike(String value) {
            addCriterion("DES_CAPITAL_ACCOUNT like", value, "desCapitalAccount");
            return (Criteria) this;
        }

        public Criteria andDesCapitalAccountNotLike(String value) {
            addCriterion("DES_CAPITAL_ACCOUNT not like", value, "desCapitalAccount");
            return (Criteria) this;
        }

        public Criteria andDesCapitalAccountIn(List<String> values) {
            addCriterion("DES_CAPITAL_ACCOUNT in", values, "desCapitalAccount");
            return (Criteria) this;
        }

        public Criteria andDesCapitalAccountNotIn(List<String> values) {
            addCriterion("DES_CAPITAL_ACCOUNT not in", values, "desCapitalAccount");
            return (Criteria) this;
        }

        public Criteria andDesCapitalAccountBetween(String value1, String value2) {
            addCriterion("DES_CAPITAL_ACCOUNT between", value1, value2, "desCapitalAccount");
            return (Criteria) this;
        }

        public Criteria andDesCapitalAccountNotBetween(String value1, String value2) {
            addCriterion("DES_CAPITAL_ACCOUNT not between", value1, value2, "desCapitalAccount");
            return (Criteria) this;
        }

        public Criteria andChannelCodeIsNull() {
            addCriterion("CHANNEL_CODE is null");
            return (Criteria) this;
        }

        public Criteria andChannelCodeIsNotNull() {
            addCriterion("CHANNEL_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andChannelCodeEqualTo(String value) {
            addCriterion("CHANNEL_CODE =", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeNotEqualTo(String value) {
            addCriterion("CHANNEL_CODE <>", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeGreaterThan(String value) {
            addCriterion("CHANNEL_CODE >", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CHANNEL_CODE >=", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeLessThan(String value) {
            addCriterion("CHANNEL_CODE <", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeLessThanOrEqualTo(String value) {
            addCriterion("CHANNEL_CODE <=", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeLike(String value) {
            addCriterion("CHANNEL_CODE like", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeNotLike(String value) {
            addCriterion("CHANNEL_CODE not like", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeIn(List<String> values) {
            addCriterion("CHANNEL_CODE in", values, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeNotIn(List<String> values) {
            addCriterion("CHANNEL_CODE not in", values, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeBetween(String value1, String value2) {
            addCriterion("CHANNEL_CODE between", value1, value2, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeNotBetween(String value1, String value2) {
            addCriterion("CHANNEL_CODE not between", value1, value2, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelTypeIsNull() {
            addCriterion("CHANNEL_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andChannelTypeIsNotNull() {
            addCriterion("CHANNEL_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andChannelTypeEqualTo(String value) {
            addCriterion("CHANNEL_TYPE =", value, "channelType");
            return (Criteria) this;
        }

        public Criteria andChannelTypeNotEqualTo(String value) {
            addCriterion("CHANNEL_TYPE <>", value, "channelType");
            return (Criteria) this;
        }

        public Criteria andChannelTypeGreaterThan(String value) {
            addCriterion("CHANNEL_TYPE >", value, "channelType");
            return (Criteria) this;
        }

        public Criteria andChannelTypeGreaterThanOrEqualTo(String value) {
            addCriterion("CHANNEL_TYPE >=", value, "channelType");
            return (Criteria) this;
        }

        public Criteria andChannelTypeLessThan(String value) {
            addCriterion("CHANNEL_TYPE <", value, "channelType");
            return (Criteria) this;
        }

        public Criteria andChannelTypeLessThanOrEqualTo(String value) {
            addCriterion("CHANNEL_TYPE <=", value, "channelType");
            return (Criteria) this;
        }

        public Criteria andChannelTypeLike(String value) {
            addCriterion("CHANNEL_TYPE like", value, "channelType");
            return (Criteria) this;
        }

        public Criteria andChannelTypeNotLike(String value) {
            addCriterion("CHANNEL_TYPE not like", value, "channelType");
            return (Criteria) this;
        }

        public Criteria andChannelTypeIn(List<String> values) {
            addCriterion("CHANNEL_TYPE in", values, "channelType");
            return (Criteria) this;
        }

        public Criteria andChannelTypeNotIn(List<String> values) {
            addCriterion("CHANNEL_TYPE not in", values, "channelType");
            return (Criteria) this;
        }

        public Criteria andChannelTypeBetween(String value1, String value2) {
            addCriterion("CHANNEL_TYPE between", value1, value2, "channelType");
            return (Criteria) this;
        }

        public Criteria andChannelTypeNotBetween(String value1, String value2) {
            addCriterion("CHANNEL_TYPE not between", value1, value2, "channelType");
            return (Criteria) this;
        }

        public Criteria andApplyAmountIsNull() {
            addCriterion("APPLY_AMOUNT is null");
            return (Criteria) this;
        }

        public Criteria andApplyAmountIsNotNull() {
            addCriterion("APPLY_AMOUNT is not null");
            return (Criteria) this;
        }

        public Criteria andApplyAmountEqualTo(BigDecimal value) {
            addCriterion("APPLY_AMOUNT =", value, "applyAmount");
            return (Criteria) this;
        }

        public Criteria andApplyAmountNotEqualTo(BigDecimal value) {
            addCriterion("APPLY_AMOUNT <>", value, "applyAmount");
            return (Criteria) this;
        }

        public Criteria andApplyAmountGreaterThan(BigDecimal value) {
            addCriterion("APPLY_AMOUNT >", value, "applyAmount");
            return (Criteria) this;
        }

        public Criteria andApplyAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("APPLY_AMOUNT >=", value, "applyAmount");
            return (Criteria) this;
        }

        public Criteria andApplyAmountLessThan(BigDecimal value) {
            addCriterion("APPLY_AMOUNT <", value, "applyAmount");
            return (Criteria) this;
        }

        public Criteria andApplyAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("APPLY_AMOUNT <=", value, "applyAmount");
            return (Criteria) this;
        }

        public Criteria andApplyAmountIn(List<BigDecimal> values) {
            addCriterion("APPLY_AMOUNT in", values, "applyAmount");
            return (Criteria) this;
        }

        public Criteria andApplyAmountNotIn(List<BigDecimal> values) {
            addCriterion("APPLY_AMOUNT not in", values, "applyAmount");
            return (Criteria) this;
        }

        public Criteria andApplyAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("APPLY_AMOUNT between", value1, value2, "applyAmount");
            return (Criteria) this;
        }

        public Criteria andApplyAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("APPLY_AMOUNT not between", value1, value2, "applyAmount");
            return (Criteria) this;
        }

        public Criteria andConfirmAmountIsNull() {
            addCriterion("CONFIRM_AMOUNT is null");
            return (Criteria) this;
        }

        public Criteria andConfirmAmountIsNotNull() {
            addCriterion("CONFIRM_AMOUNT is not null");
            return (Criteria) this;
        }

        public Criteria andConfirmAmountEqualTo(BigDecimal value) {
            addCriterion("CONFIRM_AMOUNT =", value, "confirmAmount");
            return (Criteria) this;
        }

        public Criteria andConfirmAmountNotEqualTo(BigDecimal value) {
            addCriterion("CONFIRM_AMOUNT <>", value, "confirmAmount");
            return (Criteria) this;
        }

        public Criteria andConfirmAmountGreaterThan(BigDecimal value) {
            addCriterion("CONFIRM_AMOUNT >", value, "confirmAmount");
            return (Criteria) this;
        }

        public Criteria andConfirmAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CONFIRM_AMOUNT >=", value, "confirmAmount");
            return (Criteria) this;
        }

        public Criteria andConfirmAmountLessThan(BigDecimal value) {
            addCriterion("CONFIRM_AMOUNT <", value, "confirmAmount");
            return (Criteria) this;
        }

        public Criteria andConfirmAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CONFIRM_AMOUNT <=", value, "confirmAmount");
            return (Criteria) this;
        }

        public Criteria andConfirmAmountIn(List<BigDecimal> values) {
            addCriterion("CONFIRM_AMOUNT in", values, "confirmAmount");
            return (Criteria) this;
        }

        public Criteria andConfirmAmountNotIn(List<BigDecimal> values) {
            addCriterion("CONFIRM_AMOUNT not in", values, "confirmAmount");
            return (Criteria) this;
        }

        public Criteria andConfirmAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CONFIRM_AMOUNT between", value1, value2, "confirmAmount");
            return (Criteria) this;
        }

        public Criteria andConfirmAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CONFIRM_AMOUNT not between", value1, value2, "confirmAmount");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeIsNull() {
            addCriterion("BUSINESS_CODE is null");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeIsNotNull() {
            addCriterion("BUSINESS_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeEqualTo(String value) {
            addCriterion("BUSINESS_CODE =", value, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeNotEqualTo(String value) {
            addCriterion("BUSINESS_CODE <>", value, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeGreaterThan(String value) {
            addCriterion("BUSINESS_CODE >", value, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeGreaterThanOrEqualTo(String value) {
            addCriterion("BUSINESS_CODE >=", value, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeLessThan(String value) {
            addCriterion("BUSINESS_CODE <", value, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeLessThanOrEqualTo(String value) {
            addCriterion("BUSINESS_CODE <=", value, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeLike(String value) {
            addCriterion("BUSINESS_CODE like", value, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeNotLike(String value) {
            addCriterion("BUSINESS_CODE not like", value, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeIn(List<String> values) {
            addCriterion("BUSINESS_CODE in", values, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeNotIn(List<String> values) {
            addCriterion("BUSINESS_CODE not in", values, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeBetween(String value1, String value2) {
            addCriterion("BUSINESS_CODE between", value1, value2, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBusinessCodeNotBetween(String value1, String value2) {
            addCriterion("BUSINESS_CODE not between", value1, value2, "businessCode");
            return (Criteria) this;
        }

        public Criteria andBusinessNameIsNull() {
            addCriterion("BUSINESS_NAME is null");
            return (Criteria) this;
        }

        public Criteria andBusinessNameIsNotNull() {
            addCriterion("BUSINESS_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessNameEqualTo(String value) {
            addCriterion("BUSINESS_NAME =", value, "businessName");
            return (Criteria) this;
        }

        public Criteria andBusinessNameNotEqualTo(String value) {
            addCriterion("BUSINESS_NAME <>", value, "businessName");
            return (Criteria) this;
        }

        public Criteria andBusinessNameGreaterThan(String value) {
            addCriterion("BUSINESS_NAME >", value, "businessName");
            return (Criteria) this;
        }

        public Criteria andBusinessNameGreaterThanOrEqualTo(String value) {
            addCriterion("BUSINESS_NAME >=", value, "businessName");
            return (Criteria) this;
        }

        public Criteria andBusinessNameLessThan(String value) {
            addCriterion("BUSINESS_NAME <", value, "businessName");
            return (Criteria) this;
        }

        public Criteria andBusinessNameLessThanOrEqualTo(String value) {
            addCriterion("BUSINESS_NAME <=", value, "businessName");
            return (Criteria) this;
        }

        public Criteria andBusinessNameLike(String value) {
            addCriterion("BUSINESS_NAME like", value, "businessName");
            return (Criteria) this;
        }

        public Criteria andBusinessNameNotLike(String value) {
            addCriterion("BUSINESS_NAME not like", value, "businessName");
            return (Criteria) this;
        }

        public Criteria andBusinessNameIn(List<String> values) {
            addCriterion("BUSINESS_NAME in", values, "businessName");
            return (Criteria) this;
        }

        public Criteria andBusinessNameNotIn(List<String> values) {
            addCriterion("BUSINESS_NAME not in", values, "businessName");
            return (Criteria) this;
        }

        public Criteria andBusinessNameBetween(String value1, String value2) {
            addCriterion("BUSINESS_NAME between", value1, value2, "businessName");
            return (Criteria) this;
        }

        public Criteria andBusinessNameNotBetween(String value1, String value2) {
            addCriterion("BUSINESS_NAME not between", value1, value2, "businessName");
            return (Criteria) this;
        }

        public Criteria andBeforeBalanceIsNull() {
            addCriterion("BEFORE_BALANCE is null");
            return (Criteria) this;
        }

        public Criteria andBeforeBalanceIsNotNull() {
            addCriterion("BEFORE_BALANCE is not null");
            return (Criteria) this;
        }

        public Criteria andBeforeBalanceEqualTo(BigDecimal value) {
            addCriterion("BEFORE_BALANCE =", value, "beforeBalance");
            return (Criteria) this;
        }

        public Criteria andBeforeBalanceNotEqualTo(BigDecimal value) {
            addCriterion("BEFORE_BALANCE <>", value, "beforeBalance");
            return (Criteria) this;
        }

        public Criteria andBeforeBalanceGreaterThan(BigDecimal value) {
            addCriterion("BEFORE_BALANCE >", value, "beforeBalance");
            return (Criteria) this;
        }

        public Criteria andBeforeBalanceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("BEFORE_BALANCE >=", value, "beforeBalance");
            return (Criteria) this;
        }

        public Criteria andBeforeBalanceLessThan(BigDecimal value) {
            addCriterion("BEFORE_BALANCE <", value, "beforeBalance");
            return (Criteria) this;
        }

        public Criteria andBeforeBalanceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("BEFORE_BALANCE <=", value, "beforeBalance");
            return (Criteria) this;
        }

        public Criteria andBeforeBalanceIn(List<BigDecimal> values) {
            addCriterion("BEFORE_BALANCE in", values, "beforeBalance");
            return (Criteria) this;
        }

        public Criteria andBeforeBalanceNotIn(List<BigDecimal> values) {
            addCriterion("BEFORE_BALANCE not in", values, "beforeBalance");
            return (Criteria) this;
        }

        public Criteria andBeforeBalanceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BEFORE_BALANCE between", value1, value2, "beforeBalance");
            return (Criteria) this;
        }

        public Criteria andBeforeBalanceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BEFORE_BALANCE not between", value1, value2, "beforeBalance");
            return (Criteria) this;
        }

        public Criteria andAfterBalanceIsNull() {
            addCriterion("AFTER_BALANCE is null");
            return (Criteria) this;
        }

        public Criteria andAfterBalanceIsNotNull() {
            addCriterion("AFTER_BALANCE is not null");
            return (Criteria) this;
        }

        public Criteria andAfterBalanceEqualTo(BigDecimal value) {
            addCriterion("AFTER_BALANCE =", value, "afterBalance");
            return (Criteria) this;
        }

        public Criteria andAfterBalanceNotEqualTo(BigDecimal value) {
            addCriterion("AFTER_BALANCE <>", value, "afterBalance");
            return (Criteria) this;
        }

        public Criteria andAfterBalanceGreaterThan(BigDecimal value) {
            addCriterion("AFTER_BALANCE >", value, "afterBalance");
            return (Criteria) this;
        }

        public Criteria andAfterBalanceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("AFTER_BALANCE >=", value, "afterBalance");
            return (Criteria) this;
        }

        public Criteria andAfterBalanceLessThan(BigDecimal value) {
            addCriterion("AFTER_BALANCE <", value, "afterBalance");
            return (Criteria) this;
        }

        public Criteria andAfterBalanceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("AFTER_BALANCE <=", value, "afterBalance");
            return (Criteria) this;
        }

        public Criteria andAfterBalanceIn(List<BigDecimal> values) {
            addCriterion("AFTER_BALANCE in", values, "afterBalance");
            return (Criteria) this;
        }

        public Criteria andAfterBalanceNotIn(List<BigDecimal> values) {
            addCriterion("AFTER_BALANCE not in", values, "afterBalance");
            return (Criteria) this;
        }

        public Criteria andAfterBalanceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AFTER_BALANCE between", value1, value2, "afterBalance");
            return (Criteria) this;
        }

        public Criteria andAfterBalanceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AFTER_BALANCE not between", value1, value2, "afterBalance");
            return (Criteria) this;
        }

        public Criteria andInsertDateIsNull() {
            addCriterion("INSERT_DATE is null");
            return (Criteria) this;
        }

        public Criteria andInsertDateIsNotNull() {
            addCriterion("INSERT_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andInsertDateEqualTo(String value) {
            addCriterion("INSERT_DATE =", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateNotEqualTo(String value) {
            addCriterion("INSERT_DATE <>", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateGreaterThan(String value) {
            addCriterion("INSERT_DATE >", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateGreaterThanOrEqualTo(String value) {
            addCriterion("INSERT_DATE >=", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateLessThan(String value) {
            addCriterion("INSERT_DATE <", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateLessThanOrEqualTo(String value) {
            addCriterion("INSERT_DATE <=", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateLike(String value) {
            addCriterion("INSERT_DATE like", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateNotLike(String value) {
            addCriterion("INSERT_DATE not like", value, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateIn(List<String> values) {
            addCriterion("INSERT_DATE in", values, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateNotIn(List<String> values) {
            addCriterion("INSERT_DATE not in", values, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateBetween(String value1, String value2) {
            addCriterion("INSERT_DATE between", value1, value2, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertDateNotBetween(String value1, String value2) {
            addCriterion("INSERT_DATE not between", value1, value2, "insertDate");
            return (Criteria) this;
        }

        public Criteria andInsertTimeIsNull() {
            addCriterion("INSERT_TIME is null");
            return (Criteria) this;
        }

        public Criteria andInsertTimeIsNotNull() {
            addCriterion("INSERT_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andInsertTimeEqualTo(String value) {
            addCriterion("INSERT_TIME =", value, "insertTime");
            return (Criteria) this;
        }

        public Criteria andInsertTimeNotEqualTo(String value) {
            addCriterion("INSERT_TIME <>", value, "insertTime");
            return (Criteria) this;
        }

        public Criteria andInsertTimeGreaterThan(String value) {
            addCriterion("INSERT_TIME >", value, "insertTime");
            return (Criteria) this;
        }

        public Criteria andInsertTimeGreaterThanOrEqualTo(String value) {
            addCriterion("INSERT_TIME >=", value, "insertTime");
            return (Criteria) this;
        }

        public Criteria andInsertTimeLessThan(String value) {
            addCriterion("INSERT_TIME <", value, "insertTime");
            return (Criteria) this;
        }

        public Criteria andInsertTimeLessThanOrEqualTo(String value) {
            addCriterion("INSERT_TIME <=", value, "insertTime");
            return (Criteria) this;
        }

        public Criteria andInsertTimeLike(String value) {
            addCriterion("INSERT_TIME like", value, "insertTime");
            return (Criteria) this;
        }

        public Criteria andInsertTimeNotLike(String value) {
            addCriterion("INSERT_TIME not like", value, "insertTime");
            return (Criteria) this;
        }

        public Criteria andInsertTimeIn(List<String> values) {
            addCriterion("INSERT_TIME in", values, "insertTime");
            return (Criteria) this;
        }

        public Criteria andInsertTimeNotIn(List<String> values) {
            addCriterion("INSERT_TIME not in", values, "insertTime");
            return (Criteria) this;
        }

        public Criteria andInsertTimeBetween(String value1, String value2) {
            addCriterion("INSERT_TIME between", value1, value2, "insertTime");
            return (Criteria) this;
        }

        public Criteria andInsertTimeNotBetween(String value1, String value2) {
            addCriterion("INSERT_TIME not between", value1, value2, "insertTime");
            return (Criteria) this;
        }

        public Criteria andTradeDateIsNull() {
            addCriterion("TRADE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andTradeDateIsNotNull() {
            addCriterion("TRADE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andTradeDateEqualTo(String value) {
            addCriterion("TRADE_DATE =", value, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateNotEqualTo(String value) {
            addCriterion("TRADE_DATE <>", value, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateGreaterThan(String value) {
            addCriterion("TRADE_DATE >", value, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateGreaterThanOrEqualTo(String value) {
            addCriterion("TRADE_DATE >=", value, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateLessThan(String value) {
            addCriterion("TRADE_DATE <", value, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateLessThanOrEqualTo(String value) {
            addCriterion("TRADE_DATE <=", value, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateLike(String value) {
            addCriterion("TRADE_DATE like", value, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateNotLike(String value) {
            addCriterion("TRADE_DATE not like", value, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateIn(List<String> values) {
            addCriterion("TRADE_DATE in", values, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateNotIn(List<String> values) {
            addCriterion("TRADE_DATE not in", values, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateBetween(String value1, String value2) {
            addCriterion("TRADE_DATE between", value1, value2, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateNotBetween(String value1, String value2) {
            addCriterion("TRADE_DATE not between", value1, value2, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeTimeIsNull() {
            addCriterion("TRADE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andTradeTimeIsNotNull() {
            addCriterion("TRADE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andTradeTimeEqualTo(String value) {
            addCriterion("TRADE_TIME =", value, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeNotEqualTo(String value) {
            addCriterion("TRADE_TIME <>", value, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeGreaterThan(String value) {
            addCriterion("TRADE_TIME >", value, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeGreaterThanOrEqualTo(String value) {
            addCriterion("TRADE_TIME >=", value, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeLessThan(String value) {
            addCriterion("TRADE_TIME <", value, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeLessThanOrEqualTo(String value) {
            addCriterion("TRADE_TIME <=", value, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeLike(String value) {
            addCriterion("TRADE_TIME like", value, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeNotLike(String value) {
            addCriterion("TRADE_TIME not like", value, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeIn(List<String> values) {
            addCriterion("TRADE_TIME in", values, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeNotIn(List<String> values) {
            addCriterion("TRADE_TIME not in", values, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeBetween(String value1, String value2) {
            addCriterion("TRADE_TIME between", value1, value2, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeNotBetween(String value1, String value2) {
            addCriterion("TRADE_TIME not between", value1, value2, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andSummaryIsNull() {
            addCriterion("SUMMARY is null");
            return (Criteria) this;
        }

        public Criteria andSummaryIsNotNull() {
            addCriterion("SUMMARY is not null");
            return (Criteria) this;
        }

        public Criteria andSummaryEqualTo(String value) {
            addCriterion("SUMMARY =", value, "summary");
            return (Criteria) this;
        }

        public Criteria andSummaryNotEqualTo(String value) {
            addCriterion("SUMMARY <>", value, "summary");
            return (Criteria) this;
        }

        public Criteria andSummaryGreaterThan(String value) {
            addCriterion("SUMMARY >", value, "summary");
            return (Criteria) this;
        }

        public Criteria andSummaryGreaterThanOrEqualTo(String value) {
            addCriterion("SUMMARY >=", value, "summary");
            return (Criteria) this;
        }

        public Criteria andSummaryLessThan(String value) {
            addCriterion("SUMMARY <", value, "summary");
            return (Criteria) this;
        }

        public Criteria andSummaryLessThanOrEqualTo(String value) {
            addCriterion("SUMMARY <=", value, "summary");
            return (Criteria) this;
        }

        public Criteria andSummaryLike(String value) {
            addCriterion("SUMMARY like", value, "summary");
            return (Criteria) this;
        }

        public Criteria andSummaryNotLike(String value) {
            addCriterion("SUMMARY not like", value, "summary");
            return (Criteria) this;
        }

        public Criteria andSummaryIn(List<String> values) {
            addCriterion("SUMMARY in", values, "summary");
            return (Criteria) this;
        }

        public Criteria andSummaryNotIn(List<String> values) {
            addCriterion("SUMMARY not in", values, "summary");
            return (Criteria) this;
        }

        public Criteria andSummaryBetween(String value1, String value2) {
            addCriterion("SUMMARY between", value1, value2, "summary");
            return (Criteria) this;
        }

        public Criteria andSummaryNotBetween(String value1, String value2) {
            addCriterion("SUMMARY not between", value1, value2, "summary");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("REMARK is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("REMARK is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("REMARK =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("REMARK <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("REMARK >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("REMARK >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("REMARK <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("REMARK <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("REMARK like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("REMARK not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("REMARK in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("REMARK not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("REMARK between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("REMARK not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andHelpCodeIsNull() {
            addCriterion("HELP_CODE is null");
            return (Criteria) this;
        }

        public Criteria andHelpCodeIsNotNull() {
            addCriterion("HELP_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andHelpCodeEqualTo(String value) {
            addCriterion("HELP_CODE =", value, "helpCode");
            return (Criteria) this;
        }

        public Criteria andHelpCodeNotEqualTo(String value) {
            addCriterion("HELP_CODE <>", value, "helpCode");
            return (Criteria) this;
        }

        public Criteria andHelpCodeGreaterThan(String value) {
            addCriterion("HELP_CODE >", value, "helpCode");
            return (Criteria) this;
        }

        public Criteria andHelpCodeGreaterThanOrEqualTo(String value) {
            addCriterion("HELP_CODE >=", value, "helpCode");
            return (Criteria) this;
        }

        public Criteria andHelpCodeLessThan(String value) {
            addCriterion("HELP_CODE <", value, "helpCode");
            return (Criteria) this;
        }

        public Criteria andHelpCodeLessThanOrEqualTo(String value) {
            addCriterion("HELP_CODE <=", value, "helpCode");
            return (Criteria) this;
        }

        public Criteria andHelpCodeLike(String value) {
            addCriterion("HELP_CODE like", value, "helpCode");
            return (Criteria) this;
        }

        public Criteria andHelpCodeNotLike(String value) {
            addCriterion("HELP_CODE not like", value, "helpCode");
            return (Criteria) this;
        }

        public Criteria andHelpCodeIn(List<String> values) {
            addCriterion("HELP_CODE in", values, "helpCode");
            return (Criteria) this;
        }

        public Criteria andHelpCodeNotIn(List<String> values) {
            addCriterion("HELP_CODE not in", values, "helpCode");
            return (Criteria) this;
        }

        public Criteria andHelpCodeBetween(String value1, String value2) {
            addCriterion("HELP_CODE between", value1, value2, "helpCode");
            return (Criteria) this;
        }

        public Criteria andHelpCodeNotBetween(String value1, String value2) {
            addCriterion("HELP_CODE not between", value1, value2, "helpCode");
            return (Criteria) this;
        }

        public Criteria andFeecode1IsNull() {
            addCriterion("FEECODE1 is null");
            return (Criteria) this;
        }

        public Criteria andFeecode1IsNotNull() {
            addCriterion("FEECODE1 is not null");
            return (Criteria) this;
        }

        public Criteria andFeecode1EqualTo(String value) {
            addCriterion("FEECODE1 =", value, "feecode1");
            return (Criteria) this;
        }

        public Criteria andFeecode1NotEqualTo(String value) {
            addCriterion("FEECODE1 <>", value, "feecode1");
            return (Criteria) this;
        }

        public Criteria andFeecode1GreaterThan(String value) {
            addCriterion("FEECODE1 >", value, "feecode1");
            return (Criteria) this;
        }

        public Criteria andFeecode1GreaterThanOrEqualTo(String value) {
            addCriterion("FEECODE1 >=", value, "feecode1");
            return (Criteria) this;
        }

        public Criteria andFeecode1LessThan(String value) {
            addCriterion("FEECODE1 <", value, "feecode1");
            return (Criteria) this;
        }

        public Criteria andFeecode1LessThanOrEqualTo(String value) {
            addCriterion("FEECODE1 <=", value, "feecode1");
            return (Criteria) this;
        }

        public Criteria andFeecode1Like(String value) {
            addCriterion("FEECODE1 like", value, "feecode1");
            return (Criteria) this;
        }

        public Criteria andFeecode1NotLike(String value) {
            addCriterion("FEECODE1 not like", value, "feecode1");
            return (Criteria) this;
        }

        public Criteria andFeecode1In(List<String> values) {
            addCriterion("FEECODE1 in", values, "feecode1");
            return (Criteria) this;
        }

        public Criteria andFeecode1NotIn(List<String> values) {
            addCriterion("FEECODE1 not in", values, "feecode1");
            return (Criteria) this;
        }

        public Criteria andFeecode1Between(String value1, String value2) {
            addCriterion("FEECODE1 between", value1, value2, "feecode1");
            return (Criteria) this;
        }

        public Criteria andFeecode1NotBetween(String value1, String value2) {
            addCriterion("FEECODE1 not between", value1, value2, "feecode1");
            return (Criteria) this;
        }

        public Criteria andFee1IsNull() {
            addCriterion("FEE1 is null");
            return (Criteria) this;
        }

        public Criteria andFee1IsNotNull() {
            addCriterion("FEE1 is not null");
            return (Criteria) this;
        }

        public Criteria andFee1EqualTo(BigDecimal value) {
            addCriterion("FEE1 =", value, "fee1");
            return (Criteria) this;
        }

        public Criteria andFee1NotEqualTo(BigDecimal value) {
            addCriterion("FEE1 <>", value, "fee1");
            return (Criteria) this;
        }

        public Criteria andFee1GreaterThan(BigDecimal value) {
            addCriterion("FEE1 >", value, "fee1");
            return (Criteria) this;
        }

        public Criteria andFee1GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FEE1 >=", value, "fee1");
            return (Criteria) this;
        }

        public Criteria andFee1LessThan(BigDecimal value) {
            addCriterion("FEE1 <", value, "fee1");
            return (Criteria) this;
        }

        public Criteria andFee1LessThanOrEqualTo(BigDecimal value) {
            addCriterion("FEE1 <=", value, "fee1");
            return (Criteria) this;
        }

        public Criteria andFee1In(List<BigDecimal> values) {
            addCriterion("FEE1 in", values, "fee1");
            return (Criteria) this;
        }

        public Criteria andFee1NotIn(List<BigDecimal> values) {
            addCriterion("FEE1 not in", values, "fee1");
            return (Criteria) this;
        }

        public Criteria andFee1Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("FEE1 between", value1, value2, "fee1");
            return (Criteria) this;
        }

        public Criteria andFee1NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FEE1 not between", value1, value2, "fee1");
            return (Criteria) this;
        }

        public Criteria andFeecode2IsNull() {
            addCriterion("FEECODE2 is null");
            return (Criteria) this;
        }

        public Criteria andFeecode2IsNotNull() {
            addCriterion("FEECODE2 is not null");
            return (Criteria) this;
        }

        public Criteria andFeecode2EqualTo(String value) {
            addCriterion("FEECODE2 =", value, "feecode2");
            return (Criteria) this;
        }

        public Criteria andFeecode2NotEqualTo(String value) {
            addCriterion("FEECODE2 <>", value, "feecode2");
            return (Criteria) this;
        }

        public Criteria andFeecode2GreaterThan(String value) {
            addCriterion("FEECODE2 >", value, "feecode2");
            return (Criteria) this;
        }

        public Criteria andFeecode2GreaterThanOrEqualTo(String value) {
            addCriterion("FEECODE2 >=", value, "feecode2");
            return (Criteria) this;
        }

        public Criteria andFeecode2LessThan(String value) {
            addCriterion("FEECODE2 <", value, "feecode2");
            return (Criteria) this;
        }

        public Criteria andFeecode2LessThanOrEqualTo(String value) {
            addCriterion("FEECODE2 <=", value, "feecode2");
            return (Criteria) this;
        }

        public Criteria andFeecode2Like(String value) {
            addCriterion("FEECODE2 like", value, "feecode2");
            return (Criteria) this;
        }

        public Criteria andFeecode2NotLike(String value) {
            addCriterion("FEECODE2 not like", value, "feecode2");
            return (Criteria) this;
        }

        public Criteria andFeecode2In(List<String> values) {
            addCriterion("FEECODE2 in", values, "feecode2");
            return (Criteria) this;
        }

        public Criteria andFeecode2NotIn(List<String> values) {
            addCriterion("FEECODE2 not in", values, "feecode2");
            return (Criteria) this;
        }

        public Criteria andFeecode2Between(String value1, String value2) {
            addCriterion("FEECODE2 between", value1, value2, "feecode2");
            return (Criteria) this;
        }

        public Criteria andFeecode2NotBetween(String value1, String value2) {
            addCriterion("FEECODE2 not between", value1, value2, "feecode2");
            return (Criteria) this;
        }

        public Criteria andFee2IsNull() {
            addCriterion("FEE2 is null");
            return (Criteria) this;
        }

        public Criteria andFee2IsNotNull() {
            addCriterion("FEE2 is not null");
            return (Criteria) this;
        }

        public Criteria andFee2EqualTo(BigDecimal value) {
            addCriterion("FEE2 =", value, "fee2");
            return (Criteria) this;
        }

        public Criteria andFee2NotEqualTo(BigDecimal value) {
            addCriterion("FEE2 <>", value, "fee2");
            return (Criteria) this;
        }

        public Criteria andFee2GreaterThan(BigDecimal value) {
            addCriterion("FEE2 >", value, "fee2");
            return (Criteria) this;
        }

        public Criteria andFee2GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FEE2 >=", value, "fee2");
            return (Criteria) this;
        }

        public Criteria andFee2LessThan(BigDecimal value) {
            addCriterion("FEE2 <", value, "fee2");
            return (Criteria) this;
        }

        public Criteria andFee2LessThanOrEqualTo(BigDecimal value) {
            addCriterion("FEE2 <=", value, "fee2");
            return (Criteria) this;
        }

        public Criteria andFee2In(List<BigDecimal> values) {
            addCriterion("FEE2 in", values, "fee2");
            return (Criteria) this;
        }

        public Criteria andFee2NotIn(List<BigDecimal> values) {
            addCriterion("FEE2 not in", values, "fee2");
            return (Criteria) this;
        }

        public Criteria andFee2Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("FEE2 between", value1, value2, "fee2");
            return (Criteria) this;
        }

        public Criteria andFee2NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FEE2 not between", value1, value2, "fee2");
            return (Criteria) this;
        }

        public Criteria andFeecode3IsNull() {
            addCriterion("FEECODE3 is null");
            return (Criteria) this;
        }

        public Criteria andFeecode3IsNotNull() {
            addCriterion("FEECODE3 is not null");
            return (Criteria) this;
        }

        public Criteria andFeecode3EqualTo(String value) {
            addCriterion("FEECODE3 =", value, "feecode3");
            return (Criteria) this;
        }

        public Criteria andFeecode3NotEqualTo(String value) {
            addCriterion("FEECODE3 <>", value, "feecode3");
            return (Criteria) this;
        }

        public Criteria andFeecode3GreaterThan(String value) {
            addCriterion("FEECODE3 >", value, "feecode3");
            return (Criteria) this;
        }

        public Criteria andFeecode3GreaterThanOrEqualTo(String value) {
            addCriterion("FEECODE3 >=", value, "feecode3");
            return (Criteria) this;
        }

        public Criteria andFeecode3LessThan(String value) {
            addCriterion("FEECODE3 <", value, "feecode3");
            return (Criteria) this;
        }

        public Criteria andFeecode3LessThanOrEqualTo(String value) {
            addCriterion("FEECODE3 <=", value, "feecode3");
            return (Criteria) this;
        }

        public Criteria andFeecode3Like(String value) {
            addCriterion("FEECODE3 like", value, "feecode3");
            return (Criteria) this;
        }

        public Criteria andFeecode3NotLike(String value) {
            addCriterion("FEECODE3 not like", value, "feecode3");
            return (Criteria) this;
        }

        public Criteria andFeecode3In(List<String> values) {
            addCriterion("FEECODE3 in", values, "feecode3");
            return (Criteria) this;
        }

        public Criteria andFeecode3NotIn(List<String> values) {
            addCriterion("FEECODE3 not in", values, "feecode3");
            return (Criteria) this;
        }

        public Criteria andFeecode3Between(String value1, String value2) {
            addCriterion("FEECODE3 between", value1, value2, "feecode3");
            return (Criteria) this;
        }

        public Criteria andFeecode3NotBetween(String value1, String value2) {
            addCriterion("FEECODE3 not between", value1, value2, "feecode3");
            return (Criteria) this;
        }

        public Criteria andFee3IsNull() {
            addCriterion("FEE3 is null");
            return (Criteria) this;
        }

        public Criteria andFee3IsNotNull() {
            addCriterion("FEE3 is not null");
            return (Criteria) this;
        }

        public Criteria andFee3EqualTo(BigDecimal value) {
            addCriterion("FEE3 =", value, "fee3");
            return (Criteria) this;
        }

        public Criteria andFee3NotEqualTo(BigDecimal value) {
            addCriterion("FEE3 <>", value, "fee3");
            return (Criteria) this;
        }

        public Criteria andFee3GreaterThan(BigDecimal value) {
            addCriterion("FEE3 >", value, "fee3");
            return (Criteria) this;
        }

        public Criteria andFee3GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FEE3 >=", value, "fee3");
            return (Criteria) this;
        }

        public Criteria andFee3LessThan(BigDecimal value) {
            addCriterion("FEE3 <", value, "fee3");
            return (Criteria) this;
        }

        public Criteria andFee3LessThanOrEqualTo(BigDecimal value) {
            addCriterion("FEE3 <=", value, "fee3");
            return (Criteria) this;
        }

        public Criteria andFee3In(List<BigDecimal> values) {
            addCriterion("FEE3 in", values, "fee3");
            return (Criteria) this;
        }

        public Criteria andFee3NotIn(List<BigDecimal> values) {
            addCriterion("FEE3 not in", values, "fee3");
            return (Criteria) this;
        }

        public Criteria andFee3Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("FEE3 between", value1, value2, "fee3");
            return (Criteria) this;
        }

        public Criteria andFee3NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FEE3 not between", value1, value2, "fee3");
            return (Criteria) this;
        }

        public Criteria andFeecode4IsNull() {
            addCriterion("FEECODE4 is null");
            return (Criteria) this;
        }

        public Criteria andFeecode4IsNotNull() {
            addCriterion("FEECODE4 is not null");
            return (Criteria) this;
        }

        public Criteria andFeecode4EqualTo(String value) {
            addCriterion("FEECODE4 =", value, "feecode4");
            return (Criteria) this;
        }

        public Criteria andFeecode4NotEqualTo(String value) {
            addCriterion("FEECODE4 <>", value, "feecode4");
            return (Criteria) this;
        }

        public Criteria andFeecode4GreaterThan(String value) {
            addCriterion("FEECODE4 >", value, "feecode4");
            return (Criteria) this;
        }

        public Criteria andFeecode4GreaterThanOrEqualTo(String value) {
            addCriterion("FEECODE4 >=", value, "feecode4");
            return (Criteria) this;
        }

        public Criteria andFeecode4LessThan(String value) {
            addCriterion("FEECODE4 <", value, "feecode4");
            return (Criteria) this;
        }

        public Criteria andFeecode4LessThanOrEqualTo(String value) {
            addCriterion("FEECODE4 <=", value, "feecode4");
            return (Criteria) this;
        }

        public Criteria andFeecode4Like(String value) {
            addCriterion("FEECODE4 like", value, "feecode4");
            return (Criteria) this;
        }

        public Criteria andFeecode4NotLike(String value) {
            addCriterion("FEECODE4 not like", value, "feecode4");
            return (Criteria) this;
        }

        public Criteria andFeecode4In(List<String> values) {
            addCriterion("FEECODE4 in", values, "feecode4");
            return (Criteria) this;
        }

        public Criteria andFeecode4NotIn(List<String> values) {
            addCriterion("FEECODE4 not in", values, "feecode4");
            return (Criteria) this;
        }

        public Criteria andFeecode4Between(String value1, String value2) {
            addCriterion("FEECODE4 between", value1, value2, "feecode4");
            return (Criteria) this;
        }

        public Criteria andFeecode4NotBetween(String value1, String value2) {
            addCriterion("FEECODE4 not between", value1, value2, "feecode4");
            return (Criteria) this;
        }

        public Criteria andFee4IsNull() {
            addCriterion("FEE4 is null");
            return (Criteria) this;
        }

        public Criteria andFee4IsNotNull() {
            addCriterion("FEE4 is not null");
            return (Criteria) this;
        }

        public Criteria andFee4EqualTo(BigDecimal value) {
            addCriterion("FEE4 =", value, "fee4");
            return (Criteria) this;
        }

        public Criteria andFee4NotEqualTo(BigDecimal value) {
            addCriterion("FEE4 <>", value, "fee4");
            return (Criteria) this;
        }

        public Criteria andFee4GreaterThan(BigDecimal value) {
            addCriterion("FEE4 >", value, "fee4");
            return (Criteria) this;
        }

        public Criteria andFee4GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FEE4 >=", value, "fee4");
            return (Criteria) this;
        }

        public Criteria andFee4LessThan(BigDecimal value) {
            addCriterion("FEE4 <", value, "fee4");
            return (Criteria) this;
        }

        public Criteria andFee4LessThanOrEqualTo(BigDecimal value) {
            addCriterion("FEE4 <=", value, "fee4");
            return (Criteria) this;
        }

        public Criteria andFee4In(List<BigDecimal> values) {
            addCriterion("FEE4 in", values, "fee4");
            return (Criteria) this;
        }

        public Criteria andFee4NotIn(List<BigDecimal> values) {
            addCriterion("FEE4 not in", values, "fee4");
            return (Criteria) this;
        }

        public Criteria andFee4Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("FEE4 between", value1, value2, "fee4");
            return (Criteria) this;
        }

        public Criteria andFee4NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FEE4 not between", value1, value2, "fee4");
            return (Criteria) this;
        }

        public Criteria andFeecode5IsNull() {
            addCriterion("FEECODE5 is null");
            return (Criteria) this;
        }

        public Criteria andFeecode5IsNotNull() {
            addCriterion("FEECODE5 is not null");
            return (Criteria) this;
        }

        public Criteria andFeecode5EqualTo(String value) {
            addCriterion("FEECODE5 =", value, "feecode5");
            return (Criteria) this;
        }

        public Criteria andFeecode5NotEqualTo(String value) {
            addCriterion("FEECODE5 <>", value, "feecode5");
            return (Criteria) this;
        }

        public Criteria andFeecode5GreaterThan(String value) {
            addCriterion("FEECODE5 >", value, "feecode5");
            return (Criteria) this;
        }

        public Criteria andFeecode5GreaterThanOrEqualTo(String value) {
            addCriterion("FEECODE5 >=", value, "feecode5");
            return (Criteria) this;
        }

        public Criteria andFeecode5LessThan(String value) {
            addCriterion("FEECODE5 <", value, "feecode5");
            return (Criteria) this;
        }

        public Criteria andFeecode5LessThanOrEqualTo(String value) {
            addCriterion("FEECODE5 <=", value, "feecode5");
            return (Criteria) this;
        }

        public Criteria andFeecode5Like(String value) {
            addCriterion("FEECODE5 like", value, "feecode5");
            return (Criteria) this;
        }

        public Criteria andFeecode5NotLike(String value) {
            addCriterion("FEECODE5 not like", value, "feecode5");
            return (Criteria) this;
        }

        public Criteria andFeecode5In(List<String> values) {
            addCriterion("FEECODE5 in", values, "feecode5");
            return (Criteria) this;
        }

        public Criteria andFeecode5NotIn(List<String> values) {
            addCriterion("FEECODE5 not in", values, "feecode5");
            return (Criteria) this;
        }

        public Criteria andFeecode5Between(String value1, String value2) {
            addCriterion("FEECODE5 between", value1, value2, "feecode5");
            return (Criteria) this;
        }

        public Criteria andFeecode5NotBetween(String value1, String value2) {
            addCriterion("FEECODE5 not between", value1, value2, "feecode5");
            return (Criteria) this;
        }

        public Criteria andFee5IsNull() {
            addCriterion("FEE5 is null");
            return (Criteria) this;
        }

        public Criteria andFee5IsNotNull() {
            addCriterion("FEE5 is not null");
            return (Criteria) this;
        }

        public Criteria andFee5EqualTo(BigDecimal value) {
            addCriterion("FEE5 =", value, "fee5");
            return (Criteria) this;
        }

        public Criteria andFee5NotEqualTo(BigDecimal value) {
            addCriterion("FEE5 <>", value, "fee5");
            return (Criteria) this;
        }

        public Criteria andFee5GreaterThan(BigDecimal value) {
            addCriterion("FEE5 >", value, "fee5");
            return (Criteria) this;
        }

        public Criteria andFee5GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FEE5 >=", value, "fee5");
            return (Criteria) this;
        }

        public Criteria andFee5LessThan(BigDecimal value) {
            addCriterion("FEE5 <", value, "fee5");
            return (Criteria) this;
        }

        public Criteria andFee5LessThanOrEqualTo(BigDecimal value) {
            addCriterion("FEE5 <=", value, "fee5");
            return (Criteria) this;
        }

        public Criteria andFee5In(List<BigDecimal> values) {
            addCriterion("FEE5 in", values, "fee5");
            return (Criteria) this;
        }

        public Criteria andFee5NotIn(List<BigDecimal> values) {
            addCriterion("FEE5 not in", values, "fee5");
            return (Criteria) this;
        }

        public Criteria andFee5Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("FEE5 between", value1, value2, "fee5");
            return (Criteria) this;
        }

        public Criteria andFee5NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FEE5 not between", value1, value2, "fee5");
            return (Criteria) this;
        }

        public Criteria andSubCodeIsNull() {
            addCriterion("SUB_CODE is null");
            return (Criteria) this;
        }

        public Criteria andSubCodeIsNotNull() {
            addCriterion("SUB_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andSubCodeEqualTo(String value) {
            addCriterion("SUB_CODE =", value, "subCode");
            return (Criteria) this;
        }

        public Criteria andSubCodeNotEqualTo(String value) {
            addCriterion("SUB_CODE <>", value, "subCode");
            return (Criteria) this;
        }

        public Criteria andSubCodeGreaterThan(String value) {
            addCriterion("SUB_CODE >", value, "subCode");
            return (Criteria) this;
        }

        public Criteria andSubCodeGreaterThanOrEqualTo(String value) {
            addCriterion("SUB_CODE >=", value, "subCode");
            return (Criteria) this;
        }

        public Criteria andSubCodeLessThan(String value) {
            addCriterion("SUB_CODE <", value, "subCode");
            return (Criteria) this;
        }

        public Criteria andSubCodeLessThanOrEqualTo(String value) {
            addCriterion("SUB_CODE <=", value, "subCode");
            return (Criteria) this;
        }

        public Criteria andSubCodeLike(String value) {
            addCriterion("SUB_CODE like", value, "subCode");
            return (Criteria) this;
        }

        public Criteria andSubCodeNotLike(String value) {
            addCriterion("SUB_CODE not like", value, "subCode");
            return (Criteria) this;
        }

        public Criteria andSubCodeIn(List<String> values) {
            addCriterion("SUB_CODE in", values, "subCode");
            return (Criteria) this;
        }

        public Criteria andSubCodeNotIn(List<String> values) {
            addCriterion("SUB_CODE not in", values, "subCode");
            return (Criteria) this;
        }

        public Criteria andSubCodeBetween(String value1, String value2) {
            addCriterion("SUB_CODE between", value1, value2, "subCode");
            return (Criteria) this;
        }

        public Criteria andSubCodeNotBetween(String value1, String value2) {
            addCriterion("SUB_CODE not between", value1, value2, "subCode");
            return (Criteria) this;
        }

        public Criteria andInvestorPenaltyIsNull() {
            addCriterion("INVESTOR_PENALTY is null");
            return (Criteria) this;
        }

        public Criteria andInvestorPenaltyIsNotNull() {
            addCriterion("INVESTOR_PENALTY is not null");
            return (Criteria) this;
        }

        public Criteria andInvestorPenaltyEqualTo(Integer value) {
            addCriterion("INVESTOR_PENALTY =", value, "investorPenalty");
            return (Criteria) this;
        }

        public Criteria andInvestorPenaltyNotEqualTo(Integer value) {
            addCriterion("INVESTOR_PENALTY <>", value, "investorPenalty");
            return (Criteria) this;
        }

        public Criteria andInvestorPenaltyGreaterThan(Integer value) {
            addCriterion("INVESTOR_PENALTY >", value, "investorPenalty");
            return (Criteria) this;
        }

        public Criteria andInvestorPenaltyGreaterThanOrEqualTo(Integer value) {
            addCriterion("INVESTOR_PENALTY >=", value, "investorPenalty");
            return (Criteria) this;
        }

        public Criteria andInvestorPenaltyLessThan(Integer value) {
            addCriterion("INVESTOR_PENALTY <", value, "investorPenalty");
            return (Criteria) this;
        }

        public Criteria andInvestorPenaltyLessThanOrEqualTo(Integer value) {
            addCriterion("INVESTOR_PENALTY <=", value, "investorPenalty");
            return (Criteria) this;
        }

        public Criteria andInvestorPenaltyIn(List<Integer> values) {
            addCriterion("INVESTOR_PENALTY in", values, "investorPenalty");
            return (Criteria) this;
        }

        public Criteria andInvestorPenaltyNotIn(List<Integer> values) {
            addCriterion("INVESTOR_PENALTY not in", values, "investorPenalty");
            return (Criteria) this;
        }

        public Criteria andInvestorPenaltyBetween(Integer value1, Integer value2) {
            addCriterion("INVESTOR_PENALTY between", value1, value2, "investorPenalty");
            return (Criteria) this;
        }

        public Criteria andInvestorPenaltyNotBetween(Integer value1, Integer value2) {
            addCriterion("INVESTOR_PENALTY not between", value1, value2, "investorPenalty");
            return (Criteria) this;
        }

        public Criteria andBrokerIdIsNull() {
            addCriterion("BROKER_ID is null");
            return (Criteria) this;
        }

        public Criteria andBrokerIdIsNotNull() {
            addCriterion("BROKER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andBrokerIdEqualTo(String value) {
            addCriterion("BROKER_ID =", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdNotEqualTo(String value) {
            addCriterion("BROKER_ID <>", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdGreaterThan(String value) {
            addCriterion("BROKER_ID >", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdGreaterThanOrEqualTo(String value) {
            addCriterion("BROKER_ID >=", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdLessThan(String value) {
            addCriterion("BROKER_ID <", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdLessThanOrEqualTo(String value) {
            addCriterion("BROKER_ID <=", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdLike(String value) {
            addCriterion("BROKER_ID like", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdNotLike(String value) {
            addCriterion("BROKER_ID not like", value, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdIn(List<String> values) {
            addCriterion("BROKER_ID in", values, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdNotIn(List<String> values) {
            addCriterion("BROKER_ID not in", values, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdBetween(String value1, String value2) {
            addCriterion("BROKER_ID between", value1, value2, "brokerId");
            return (Criteria) this;
        }

        public Criteria andBrokerIdNotBetween(String value1, String value2) {
            addCriterion("BROKER_ID not between", value1, value2, "brokerId");
            return (Criteria) this;
        }
    }

    /**
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}